package com.dao;

import com.bean.*;

import java.sql.SQLException;
import java.util.List;

public interface BhSyCaseDao {

    /**
     * 用户登录
     * @param account 用户账号
     * @param pwd   用户密码
     * @return 用户对象
     * @throws SQLException
     */
    public BhUser bhLogin(String account, int pwd) throws SQLException;

    /**
     * 用户权限路径查询
     * @param System 用户权限
     * @return
     * @throws SQLException
     */
    public List<BhRole> bhSelRole(int System)throws SQLException;

    /**
     * 用户题库查询
     * @param uID 用户ID
     * @return
     * @throws SQLException
     */
    public List<UserTopicKu> bhSelUserTK(int uID) throws SQLException;
    /**
     * 通过Excel导入题目,如题目以存在该用户中则跳过
     */
    public void bhInertExcelTopic(List<Bhtopic> list,int uid) throws SQLException;

    /**
     * 根据题目的问题和类型进行查询题目的ID
     * @param list
     * @throws SQLException
     */
    public List<Bhtopic> selBhTopicForProAType(List<Bhtopic> list) throws SQLException;
    /**
     * 添加考试题目到数据库
     * @param btm
     * @throws SQLException
     */
    public void addBhTopIcTm(Bhcasetm btm) throws SQLException;

    /**
     * 将考试试卷添加数据库
     * @param bhcase
     * @throws SQLException
     */
    public void addBhCase(Bhcase bhcase) throws SQLException;

    public List<Bhtopic> getBhTopicForPor(int uId,String[] tPor) throws SQLException;
}
